﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" MasterPageFile="~/Institute_of_Fine_Arts.master" Title = "Home Page"%>

<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxNewsControl" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent" >
    <dx:ASPxRoundPanel ID="ASPxRoundPanel1" runat="server" 
        HeaderText="Upcoming competitions" HorizontalAlign="Center" Width="100%" 
        Font-Names="Algerian" Font-Size="Large" ForeColor="Black">
        <HeaderStyle Font-Bold="True" Font-Italic="False" ForeColor="Black" 
            HorizontalAlign="Center" />
        <PanelCollection>
            <dx:PanelContent runat="server" SupportsDisabledAttribute="True">
                <dx:ASPxNewsControl ID="ASPxNewsControl1" runat="server" 
        CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
        DataSourceID="SqlDataSource2" DateField="Start_Date" 
        HeaderTextField="Competition_Name" NameField="CompetitionID" 
        PagerAlign="Justify" PagerPanelSpacing="1px" 
        SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" 
        TextField="Competition_Detail" Width="100%" NavigateUrlField="CompetitionID" 
                    NavigateUrlFormatString="~/Pages/Competition_Details.aspx?id={0}">
                    <Items>
                        <dx:NewsItem HeaderText="Ao thu" Name="1" 
                Text="Ao thu lạnh lẽo, nước trong veo" Date="2013-01-07" NavigateUrl="1">
                        </dx:NewsItem>
                        <dx:NewsItem HeaderText="Đầm sen" Name="2" 
                Text="Trong đầm gì đẹp bằng sen" Date="2013-01-07" NavigateUrl="2">
                        </dx:NewsItem>
                        <dx:NewsItem HeaderText="Người hàng xóm" Name="3" 
                Text="Nhà nàng ở cạnh nhà tôi.." Date="2013-01-07" NavigateUrl="3">
                        </dx:NewsItem>
                    </Items>
                    <ItemSettings TailPosition="KeepWithLastWord" 
                        MaxLength="100" TailText="Details">
                    </ItemSettings>
                    <BackToTopImage>
                        <SpriteProperties CssClass="dxWeb_ncBackToTop_DevEx" />
                    </BackToTopImage>
                    <BackToTopStyle HorizontalAlign="Right" ImageSpacing="3px">
                    </BackToTopStyle>
                    <ItemDateStyle Spacing="0px">
                    </ItemDateStyle>
                    <ItemContentStyle LineHeight="14px">
                    </ItemContentStyle>
                    <ItemHeaderStyle Font-Bold="True" Font-Names="Arial" ForeColor="#FF6600" 
                        Font-Size="Large">
                    </ItemHeaderStyle>
                    <ItemTailStyle Font-Italic="True">
                    </ItemTailStyle>
                    <ItemLeftPanelStyle Spacing="37px">
                        <Paddings PaddingTop="3px" />
                    </ItemLeftPanelStyle>
                    <PagerSettings ShowDefaultImages="True">
                        <AllButton Text="">
                        </AllButton>
                        <FirstPageButton Text="">
                        </FirstPageButton>
                        <LastPageButton Text="">
                        </LastPageButton>
                        <NextPageButton Text="">
                        </NextPageButton>
                        <PrevPageButton Text="">
                        </PrevPageButton>
                        <Summary Position="Inside" />
                    </PagerSettings>
                    <LoadingPanelImage Url="~/App_Themes/DevEx/Web/Loading.gif">
                    </LoadingPanelImage>
                    <LoadingPanelStyle ImageSpacing="5px">
                    </LoadingPanelStyle>
                    <DisabledStyle ForeColor="#B1B1B8">
                    </DisabledStyle>
                </dx:ASPxNewsControl>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:Institte_of_Fine_ArtsConnectionString %>" 
                    SelectCommand="SELECT [CompetitionID], [Competition_Name], [Competition_Detail], [Start_Date] FROM [Competition] WHERE ([Start_Date] &gt; @Start_Date) ORDER BY [Start_Date] DESC">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="" Name="Start_Date" 
                            SessionField="Today" Type="DateTime" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </dx:PanelContent>
        </PanelCollection>
    </dx:ASPxRoundPanel>

    <dx:ASPxRoundPanel ID="ASPxRoundPanel2" runat="server" 
        HeaderText="ongoing competitions" HorizontalAlign="Center" Width="100%" 
        Font-Names="Algerian" Font-Size="Large" ForeColor="Black">
        <HeaderStyle Font-Bold="True" Font-Italic="False" ForeColor="Black" 
            HorizontalAlign="Center" />
        <PanelCollection>
            <dx:PanelContent runat="server" SupportsDisabledAttribute="True">
                <dx:ASPxNewsControl ID="ASPxNewsControl2" runat="server" 
        CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
        DataSourceID="SqlDataSource1" DateField="Start_Date" 
        HeaderTextField="Competition_Name" NameField="CompetitionID" 
        PagerAlign="Justify" PagerPanelSpacing="1px" 
        SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" 
        TextField="Competition_Detail" Width="100%" NavigateUrlField="CompetitionID" 
                    NavigateUrlFormatString="~/Pages/Competition_Details.aspx?id={0}">
                    <Items>
                        <dx:NewsItem HeaderText="Ao thu" Name="1" 
                Text="Ao thu lạnh lẽo, nước trong veo" Date="2013-01-07" NavigateUrl="1">
                        </dx:NewsItem>
                        <dx:NewsItem HeaderText="Đầm sen" Name="2" 
                Text="Trong đầm gì đẹp bằng sen" Date="2013-01-07" NavigateUrl="2">
                        </dx:NewsItem>
                        <dx:NewsItem HeaderText="Người hàng xóm" Name="3" 
                Text="Nhà nàng ở cạnh nhà tôi.." Date="2013-01-07" NavigateUrl="3">
                        </dx:NewsItem>
                    </Items>
                    <ItemSettings TailPosition="KeepWithLastWord" 
                        MaxLength="100" TailText="Details">
                    </ItemSettings>
                    <BackToTopImage>
                        <SpriteProperties CssClass="dxWeb_ncBackToTop_DevEx" />
                    </BackToTopImage>
                    <BackToTopStyle HorizontalAlign="Right" ImageSpacing="3px">
                    </BackToTopStyle>
                    <ItemDateStyle Spacing="0px">
                    </ItemDateStyle>
                    <ItemContentStyle LineHeight="14px">
                    </ItemContentStyle>
                    <ItemHeaderStyle Font-Bold="True" Font-Names="Arial" ForeColor="#FF6600" 
                        Font-Size="Large">
                    </ItemHeaderStyle>
                    <ItemTailStyle Font-Italic="True">
                    </ItemTailStyle>
                    <ItemLeftPanelStyle Spacing="37px">
                        <Paddings PaddingTop="3px" />
                    </ItemLeftPanelStyle>
                    <PagerSettings ShowDefaultImages="True">
                        <AllButton Text="">
                        </AllButton>
                        <FirstPageButton Text="">
                        </FirstPageButton>
                        <LastPageButton Text="">
                        </LastPageButton>
                        <NextPageButton Text="">
                        </NextPageButton>
                        <PrevPageButton Text="">
                        </PrevPageButton>
                        <Summary Position="Inside" />
                    </PagerSettings>
                    <LoadingPanelImage Url="~/App_Themes/DevEx/Web/Loading.gif">
                    </LoadingPanelImage>
                    <LoadingPanelStyle ImageSpacing="5px">
                    </LoadingPanelStyle>
                    <DisabledStyle ForeColor="#B1B1B8">
                    </DisabledStyle>
                </dx:ASPxNewsControl>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:Institte_of_Fine_ArtsConnectionString %>" 
                    SelectCommand="SELECT [CompetitionID], [Competition_Name], [Start_Date], [Competition_Detail], [End_Date] FROM [Competition] WHERE (([Start_Date] &lt;= @Start_Date) AND ([End_Date] &gt;= @End_Date)) ORDER BY [Start_Date] DESC">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="" Name="Start_Date" 
                            SessionField="Today" Type="DateTime" />
                        <asp:SessionParameter DefaultValue="" Name="End_Date" 
                            SessionField="Today" Type="DateTime" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </dx:PanelContent>
        </PanelCollection>
    </dx:ASPxRoundPanel>
    <dx:ASPxRoundPanel ID="ASPxRoundPanel3" runat="server" Font-Names="Algerian" 
                    Font-Size="Large" ForeColor="Black" HeaderText="Exhibition" 
                    HorizontalAlign="Center" Width="100%">
                    <HeaderStyle Font-Bold="True" Font-Italic="False" ForeColor="Black" 
                        HorizontalAlign="Center" />
                    <PanelCollection>
                        <dx:PanelContent ID="PanelContent1" runat="server" SupportsDisabledAttribute="True">
                            <dx:ASPxNewsControl ID="ASPxNewsControl3" runat="server" 
                                CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                DataSourceID="SqlDataSource3" NameField="ExhibitionID" 
                                NavigateUrlField="ExhibitionID" 
                                NavigateUrlFormatString="" 
                                PagerAlign="Justify" PagerPanelSpacing="1px" 
                                SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" 
                                TextField="Exhibition_Details" Width="100%">
                                <Items>
                                    <dx:NewsItem Date="2013-01-07" HeaderText="Ao thu" Name="1" NavigateUrl="1" 
                                        Text="Ao thu lạnh lẽo, nước trong veo">
                                    </dx:NewsItem>
                                    <dx:NewsItem Date="2013-01-07" HeaderText="Đầm sen" Name="2" NavigateUrl="2" 
                                        Text="Trong đầm gì đẹp bằng sen">
                                    </dx:NewsItem>
                                    <dx:NewsItem Date="2013-01-07" HeaderText="Người hàng xóm" Name="3" 
                                        NavigateUrl="3" Text="Nhà nàng ở cạnh nhà tôi..">
                                    </dx:NewsItem>
                                </Items>
                                <ItemSettings MaxLength="1000" TailPosition="KeepWithLastWord">
                                </ItemSettings>
                                <BackToTopImage>
                                    <SpriteProperties CssClass="dxWeb_ncBackToTop_DevEx" />
                                </BackToTopImage>
                                <BackToTopStyle HorizontalAlign="Right" ImageSpacing="3px">
                                </BackToTopStyle>
                                <ItemDateStyle Spacing="0px">
                                </ItemDateStyle>
                                <ItemContentStyle LineHeight="14px">
                                </ItemContentStyle>
                                <ItemHeaderStyle Font-Bold="True" Font-Names="Arial" Font-Size="Large" 
                                    ForeColor="#FF6600">
                                </ItemHeaderStyle>
                                <ItemTailStyle Font-Italic="True">
                                </ItemTailStyle>
                                <ItemLeftPanelStyle Spacing="37px">
                                    <Paddings PaddingTop="3px" />
                                </ItemLeftPanelStyle>
                                <PagerSettings ShowDefaultImages="True">
                                    <AllButton Text="">
                                    </AllButton>
                                    <FirstPageButton Text="">
                                    </FirstPageButton>
                                    <LastPageButton Text="">
                                    </LastPageButton>
                                    <NextPageButton Text="">
                                    </NextPageButton>
                                    <PrevPageButton Text="">
                                    </PrevPageButton>
                                    <Summary Position="Inside" />
                                </PagerSettings>
                                <LoadingPanelImage Url="~/App_Themes/DevEx/Web/Loading.gif">
                                </LoadingPanelImage>
                                <LoadingPanelStyle ImageSpacing="5px">
                                </LoadingPanelStyle>
                                <DisabledStyle ForeColor="#B1B1B8">
                                </DisabledStyle>
                            </dx:ASPxNewsControl>
                            <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:Institte_of_Fine_ArtsConnectionString %>" 
                                SelectCommand="SELECT * FROM [Exhibition] ORDER BY [ExhibitionID] DESC">
                            </asp:SqlDataSource>
                        </dx:PanelContent>
                    </PanelCollection>
                </dx:ASPxRoundPanel>

                <dx:ASPxRoundPanel runat="server" HeaderText="Awrads" 
            HorizontalAlign="Center" Width="100%" Font-Names="Algerian" Font-Size="Large" 
            ForeColor="Black" ID="ASPxRoundPanel4">
<HeaderStyle HorizontalAlign="Center" Font-Bold="True" Font-Italic="False" ForeColor="Black"></HeaderStyle>
<PanelCollection>
<dx:PanelContent ID="PanelContent2" runat="server" SupportsDisabledAttribute="True">
                            <dx:ASPxNewsControl runat="server" NameField="Award_Details_ID" 
                                NavigateUrlField="Award_Details_ID" NavigateUrlFormatString="" 
                                TextField="Awrad_Details" PagerAlign="Justify" PagerPanelSpacing="1px" 
                                SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" 
                                DataSourceID="SqlDataSource4" CssPostfix="DevEx" 
                                CssFilePath="~/App_Themes/DevEx/{0}/styles.css" Width="100%" 
                                ID="ASPxNewsControl4" DateField="Awrad_Date" HeaderTextField="Award_Name" 
                                ImageUrlField="Painting"><Items>
                                        <dx:NewsItem HeaderText="Ao thu" Date="2013-01-07" Text="Ao thu lạnh lẽo, nước trong veo" Name="1" NavigateUrl="1"></dx:NewsItem>
                                        <dx:NewsItem HeaderText="Đầm sen" Date="2013-01-07" Text="Trong đầm g&#236; đẹp bằng sen" Name="2" NavigateUrl="2"></dx:NewsItem>
                                        <dx:NewsItem HeaderText="Người h&#224;ng x&#243;m" Date="2013-01-07" 
                                                                                Text="Nh&#224; n&#224;ng ở cạnh nh&#224; t&#244;i.." Name="3" NavigateUrl="3"></dx:NewsItem>
                                        </Items>

                                        <ItemSettings MaxLength="100" TailPosition="KeepWithLastWord" TailText="Details"></ItemSettings>

                                        <BackToTopImage>
                                        <SpriteProperties CssClass="dxWeb_ncBackToTop_DevEx"></SpriteProperties>
                                        </BackToTopImage>

                                        <BackToTopStyle ImageSpacing="3px" HorizontalAlign="Right"></BackToTopStyle>

                                        <ItemDateStyle Spacing="0px"></ItemDateStyle>

                                        <ItemContentStyle LineHeight="14px"></ItemContentStyle>

                                        <ItemHeaderStyle Font-Bold="True" Font-Names="Arial" Font-Size="Large" ForeColor="#FF6600"></ItemHeaderStyle>

                                        <ItemTailStyle Font-Italic="True"></ItemTailStyle>

                                        <ItemLeftPanelStyle Spacing="37px">
                                        <Paddings PaddingTop="3px"></Paddings>
                                        </ItemLeftPanelStyle>

                                        <PagerSettings ShowDefaultImages="True">
                                        <AllButton Text=""></AllButton>

                                        <FirstPageButton Text=""></FirstPageButton>

                                        <LastPageButton Text=""></LastPageButton>

                                        <NextPageButton Text=""></NextPageButton>

                                        <PrevPageButton Text=""></PrevPageButton>

                                        <Summary Position="Inside"></Summary>
                                        </PagerSettings>

                                        <LoadingPanelImage Url="~/App_Themes/DevEx/Web/Loading.gif" Height="200px" Width="200px"></LoadingPanelImage>

                                        <LoadingPanelStyle ImageSpacing="5px"></LoadingPanelStyle>

                                        <DisabledStyle ForeColor="#B1B1B8"></DisabledStyle>
                                        </dx:ASPxNewsControl>

                            <asp:SqlDataSource runat="server" 
                                ConnectionString="<%$ ConnectionStrings:Institte_of_Fine_ArtsConnectionString %>" 
                                SelectCommand="SELECT Posting.Painting, Posting.Description, Award.Award_Name, Award.Awrad_Details, Award_Details.Awrad_Date, Award_Details.Award_Details_ID FROM Award INNER JOIN Award_Details ON Award.AwardID = Award_Details.AwardID INNER JOIN Posting ON Award_Details.PostingID = Posting.PostingID" 
                                ID="SqlDataSource4"></asp:SqlDataSource>

                            <dx:ASPxButton ID="ASPxButton1" runat="server" Text="ASPxButton">
                            </dx:ASPxButton>

                        </dx:PanelContent>
</PanelCollection>
</dx:ASPxRoundPanel>
    </asp:Content>